Click Here!
home account info subscribe login search My ITKnowledge FAQ/help site map contact us


 
Brief Full
 Advanced
      Search
 Search Tips
To access the contents, click the chapter and section titles.

Oracle Performance Tuning and Optimization
(Publisher: Macmillan Computer Publishing)
Author(s): Edward Whalen
ISBN: 067230886x
Publication Date: 04/01/96

Bookmark It

Search this book:
 
Previous Table of Contents Next


Reports Designer

Reports Designer is the Developer/2000 tool for creating reports applications for the Windows, Macintosh, and Motif environments. The reporting tool can build graphical and printed forms easily and quickly and is very configurable.

As with the Forms Designer, applications developed with the Oracle Reports Designer are typically fairly optimized. The actual query used in your report is defined as part of building the report. To modify this SQL statement, follow these steps:

1.  Highlight the query you want to review by single-clicking it.
2.  Pull down and select Properties from the Tools menu (see Figure 35.3).


Figure 35.3  Selecting the query to modify.


The Query Editor opens; use this window to view or modify the query used in this report (see Figure 35.4).


Figure 35.4  The Query Editor window.

Once you invoke the Query Editor, you can view or modify the SQL statement for optimal performance.

By using the Query Editor, you can change your SQL statements to be more efficient. In this manner, you can completely optimize the application created by the Oracle Reports Designer tool.


TIP:  As with the Forms Designer, the Reports Designer tool is a great way to add hints to your report queries. The hints you add can inform the optimizer of such things as any additional parallelism you want to include.

You can examine the inputs to the report using the Data Model Editor (see Figure 35.5) to get a fairly good idea of the number of queries going into the report. By optimizing all of them, you can make the report very efficient.


Figure 35.5  The Data Model Editor window.

It is entirely possible that there is no need to add additional optimization. However, by having the option to perform additional tuning and optimization on the SQL statements, you may be able to improve performance.

Graphics Designer

Graphics Designer is a tool for building graphical displays that can be used in a stand-alone fashion or in conjunction with the Oracle Forms Designer and Reports Designer. The Oracle Graphics Designer is similar to the Report Designer in that the creation of the query is part of the definition process.

Because you are creating the query that will be used in the creation of the final chart, you have complete flexibility to optimize this query. The steps necessary to modify a query once the application has been written are as follows:

1.  Highlight the query you want to review by single-clicking it.
2.  Pull down and select Properties from the Tools menu (see Figure 35.6).


Figure 35.6  Selecting the query properties.


The Query Properties Editor window opens; you can use this window to view or modify the query used in this report (see Figure 35.7).


Figure 35.7  The Query Properties Editor window.

Once you invoke the Query Properties Editor, you can view or modify the SQL statement for optimal performance.

By using the Query Properties Editor, you can change your SQL statements to be more efficient. In this manner, you can completely optimize the SQL statements used in the application created by the Oracle Graphics Designer tool.

Procedure Builder

The Oracle Procedure Builder is an integrated environment for editing, developing, and debugging PL/SQL programs, stored procedures, and database triggers. The Oracle Procedure Builder is integrated into the Developer/2000 suite of tools.

The Procedure Builder does not create procedures or triggers for you; rather, it assists you in the development of those objects. As such, there is no type of optimization you can do to the Procedure Builder.

The following options are available from the Procedure Builder to assist you in the development of these objects:


Option Description

Program Unit Editor Used for creating procedures, functions, and packages.
PL/SQL Interpreter Useful for debugging specific statements.
Stored Program Unit Editor Used to view and edit stored programs defined in your database (see Figure 35.8).
Database Trigger Editor Used to develop and debug triggers (see Figure 35.9).
Source Code Control The built-in Source Code Control lets multiple developers keep track of changing source code versions easily and effectively.


Figure 35.8  The Stored Program Unit Editor.


Figure 35.9  The Database Trigger Editor.

By using the PL/SQL interpreter, you have the ability to debug objects with the built-in debugging and tracing facilities. This can be useful for editing and obtaining information about stored programs in your database. The Database Trigger Editor allows you to view and modify the trigger body as well as change the trigger definitions.

By using the various features included in the Procedure Builder (such as the development and debugging tools as well as the source-code control features), you can improve your productivity when developing applications.

Review of Developer/2000

Oracle Developer/2000 is a suite of tools designed to rapidly develop full-featured applications. As you have seen, these tools can be quite useful in the development and enhancement of forms, reports, and graphics objects. When you combine them with Oracle SQL development tools, they can be extremely helpful when you are developing large applications.

If you are looking for something smaller and lighter than Developer/2000, you may want to consider Oracle Power Objects.

Power Objects

Oracle Power Objects is relatively new and gaining in popularity. Power Objects is an application development tool that can work with your Oracle database or with a small stand-alone database that comes with it called BLAZE. Power Objects is object oriented and can have you developing small applications in a matter of minutes.

Power Objects is very easy to use and powerful. By designing applications in an object-oriented fashion, you can easily reuse objects and save time. With Oracle Power Objects, you have the ability to build forms, reports, and classes. You can build on the classes, making Oracle Power Objects quite useful.

As with all the tools described in this chapter, Power Objects uses a drag-and-drop interface, which makes all the tools easy to get started with. The following sections describe the three major areas of Power Objects development.


Previous Table of Contents Next


Products |  Contact Us |  About Us |  Privacy  |  Ad Info  |  Home

Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc.
All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited.